﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="CDmShpPageMall" targetNamespace="http://tempuri.org/CDmShpPageMall.xsd" xmlns:mstns="http://tempuri.org/CDmShpPageMall.xsd" xmlns="http://tempuri.org/CDmShpPageMall.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="msBscConnectionString1" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="msBscConnectionString1 (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.msBsc.Xsd.DataTds.Properties.Settings.GlobalReference.Default.msBscConnectionString1" Provider="System.Data.SqlClient" />
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="kokoConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="kokoConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.msBsc.Xsd.DataTds.Properties.Settings.GlobalReference.Default.kokoConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SHP_PAGE_MALLTableAdapter" GeneratorDataComponentClassName="SHP_PAGE_MALLTableAdapter" Name="SHP_PAGE_MALL" UserDataComponentName="SHP_PAGE_MALLTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="kokoConnectionString (Settings)" DbObjectName="koko.dbo.SHP_PAGE_MALL" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[SHP_PAGE_MALL] WHERE (([PAGE_NO] = @Original_PAGE_NO) AND ((@IsNull_SEQ_NUM = 1 AND [SEQ_NUM] IS NULL) OR ([SEQ_NUM] = @Original_SEQ_NUM)) AND ((@IsNull_PAGE_NME = 1 AND [PAGE_NME] IS NULL) OR ([PAGE_NME] = @Original_PAGE_NME)) AND ((@IsNull_PAGE_LOGO_URL = 1 AND [PAGE_LOGO_URL] IS NULL) OR ([PAGE_LOGO_URL] = @Original_PAGE_LOGO_URL)) AND ((@IsNull_AD_IMG1 = 1 AND [AD_IMG1] IS NULL) OR ([AD_IMG1] = @Original_AD_IMG1)) AND ((@IsNull_AD_LINK1 = 1 AND [AD_LINK1] IS NULL) OR ([AD_LINK1] = @Original_AD_LINK1)) AND ((@IsNull_AD_IMG2 = 1 AND [AD_IMG2] IS NULL) OR ([AD_IMG2] = @Original_AD_IMG2)) AND ((@IsNull_AD_LINK2 = 1 AND [AD_LINK2] IS NULL) OR ([AD_LINK2] = @Original_AD_LINK2)) AND ((@IsNull_AD_IMG3 = 1 AND [AD_IMG3] IS NULL) OR ([AD_IMG3] = @Original_AD_IMG3)) AND ((@IsNull_AD_LINK3 = 1 AND [AD_LINK3] IS NULL) OR ([AD_LINK3] = @Original_AD_LINK3)) AND ((@IsNull_DATA_SQL1 = 1 AND [DATA_SQL1] IS NULL) OR ([DATA_SQL1] = @Original_DATA_SQL1)) AND ((@IsNull_DATA_GROUP_LIST1 = 1 AND [DATA_GROUP_LIST1] IS NULL) OR ([DATA_GROUP_LIST1] = @Original_DATA_GROUP_LIST1)) AND ((@IsNull_DATA_SQL2 = 1 AND [DATA_SQL2] IS NULL) OR ([DATA_SQL2] = @Original_DATA_SQL2)) AND ((@IsNull_DATA_GROUP_LIST2 = 1 AND [DATA_GROUP_LIST2] IS NULL) OR ([DATA_GROUP_LIST2] = @Original_DATA_GROUP_LIST2)) AND ((@IsNull_DATA_SQL3 = 1 AND [DATA_SQL3] IS NULL) OR ([DATA_SQL3] = @Original_DATA_SQL3)) AND ((@IsNull_DATA_GROUP_LIST3 = 1 AND [DATA_GROUP_LIST3] IS NULL) OR ([DATA_GROUP_LIST3] = @Original_DATA_GROUP_LIST3)) AND ((@IsNull_ASPX_PAGE_URL = 1 AND [ASPX_PAGE_URL] IS NULL) OR ([ASPX_PAGE_URL] = @Original_ASPX_PAGE_URL)) AND ((@IsNull_HOST_NME = 1 AND [HOST_NME] IS NULL) OR ([HOST_NME] = @Original_HOST_NME)) AND ((@IsNull_MALL_TYPE = 1 AND [MALL_TYPE] IS NULL) OR ([MALL_TYPE] = @Original_MALL_TYPE)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PAGE_NO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PAGE_NO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SEQ_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SEQ_NUM" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SEQ_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SEQ_NUM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PAGE_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PAGE_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PAGE_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PAGE_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PAGE_LOGO_URL" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PAGE_LOGO_URL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PAGE_LOGO_URL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PAGE_LOGO_URL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AD_IMG1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AD_IMG1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AD_IMG1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AD_IMG1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AD_LINK1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AD_LINK1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AD_LINK1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AD_LINK1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AD_IMG2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AD_IMG2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AD_IMG2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AD_IMG2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AD_LINK2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AD_LINK2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AD_LINK2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AD_LINK2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AD_IMG3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AD_IMG3" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AD_IMG3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AD_IMG3" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AD_LINK3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AD_LINK3" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AD_LINK3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AD_LINK3" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DATA_SQL1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DATA_SQL1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DATA_SQL1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DATA_SQL1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DATA_GROUP_LIST1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DATA_GROUP_LIST1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DATA_GROUP_LIST1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DATA_GROUP_LIST1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DATA_SQL2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DATA_SQL2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DATA_SQL2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DATA_SQL2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DATA_GROUP_LIST2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DATA_GROUP_LIST2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DATA_GROUP_LIST2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DATA_GROUP_LIST2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DATA_SQL3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DATA_SQL3" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DATA_SQL3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DATA_SQL3" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DATA_GROUP_LIST3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DATA_GROUP_LIST3" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DATA_GROUP_LIST3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DATA_GROUP_LIST3" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ASPX_PAGE_URL" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ASPX_PAGE_URL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ASPX_PAGE_URL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ASPX_PAGE_URL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HOST_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HOST_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_HOST_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="HOST_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MALL_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MALL_TYPE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_MALL_TYPE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MALL_TYPE" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[SHP_PAGE_MALL] ([PAGE_NO], [SEQ_NUM], [PAGE_NME], [PAGE_LOGO_URL], [AD_IMG1], [AD_LINK1], [AD_IMG2], [AD_LINK2], [AD_IMG3], [AD_LINK3], [DATA_SQL1], [DATA_GROUP_LIST1], [DATA_SQL2], [DATA_GROUP_LIST2], [DATA_SQL3], [DATA_GROUP_LIST3], [ASPX_PAGE_URL], [HOST_NME], [MALL_TYPE]) VALUES (@PAGE_NO, @SEQ_NUM, @PAGE_NME, @PAGE_LOGO_URL, @AD_IMG1, @AD_LINK1, @AD_IMG2, @AD_LINK2, @AD_IMG3, @AD_LINK3, @DATA_SQL1, @DATA_GROUP_LIST1, @DATA_SQL2, @DATA_GROUP_LIST2, @DATA_SQL3, @DATA_GROUP_LIST3, @ASPX_PAGE_URL, @HOST_NME, @MALL_TYPE);
SELECT PAGE_NO, SEQ_NUM, PAGE_NME, PAGE_LOGO_URL, AD_IMG1, AD_LINK1, AD_IMG2, AD_LINK2, AD_IMG3, AD_LINK3, DATA_SQL1, DATA_GROUP_LIST1, DATA_SQL2, DATA_GROUP_LIST2, DATA_SQL3, DATA_GROUP_LIST3, ASPX_PAGE_URL, HOST_NME, MALL_TYPE FROM SHP_PAGE_MALL WHERE (PAGE_NO = @PAGE_NO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PAGE_NO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PAGE_NO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SEQ_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SEQ_NUM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PAGE_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PAGE_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PAGE_LOGO_URL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PAGE_LOGO_URL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AD_IMG1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AD_IMG1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AD_LINK1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AD_LINK1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AD_IMG2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AD_IMG2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AD_LINK2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AD_LINK2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AD_IMG3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AD_IMG3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AD_LINK3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AD_LINK3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DATA_SQL1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DATA_SQL1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DATA_GROUP_LIST1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DATA_GROUP_LIST1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DATA_SQL2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DATA_SQL2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DATA_GROUP_LIST2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DATA_GROUP_LIST2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DATA_SQL3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DATA_SQL3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DATA_GROUP_LIST3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DATA_GROUP_LIST3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ASPX_PAGE_URL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ASPX_PAGE_URL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@HOST_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="HOST_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MALL_TYPE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MALL_TYPE" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT PAGE_NO, SEQ_NUM, PAGE_NME, PAGE_LOGO_URL, AD_IMG1, AD_LINK1, AD_IMG2, AD_LINK2, AD_IMG3, AD_LINK3, DATA_SQL1, DATA_GROUP_LIST1, DATA_SQL2, DATA_GROUP_LIST2, DATA_SQL3, DATA_GROUP_LIST3, ASPX_PAGE_URL, HOST_NME, MALL_TYPE FROM dbo.SHP_PAGE_MALL</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[SHP_PAGE_MALL] SET [PAGE_NO] = @PAGE_NO, [SEQ_NUM] = @SEQ_NUM, [PAGE_NME] = @PAGE_NME, [PAGE_LOGO_URL] = @PAGE_LOGO_URL, [AD_IMG1] = @AD_IMG1, [AD_LINK1] = @AD_LINK1, [AD_IMG2] = @AD_IMG2, [AD_LINK2] = @AD_LINK2, [AD_IMG3] = @AD_IMG3, [AD_LINK3] = @AD_LINK3, [DATA_SQL1] = @DATA_SQL1, [DATA_GROUP_LIST1] = @DATA_GROUP_LIST1, [DATA_SQL2] = @DATA_SQL2, [DATA_GROUP_LIST2] = @DATA_GROUP_LIST2, [DATA_SQL3] = @DATA_SQL3, [DATA_GROUP_LIST3] = @DATA_GROUP_LIST3, [ASPX_PAGE_URL] = @ASPX_PAGE_URL, [HOST_NME] = @HOST_NME, [MALL_TYPE] = @MALL_TYPE WHERE (([PAGE_NO] = @Original_PAGE_NO) AND ((@IsNull_SEQ_NUM = 1 AND [SEQ_NUM] IS NULL) OR ([SEQ_NUM] = @Original_SEQ_NUM)) AND ((@IsNull_PAGE_NME = 1 AND [PAGE_NME] IS NULL) OR ([PAGE_NME] = @Original_PAGE_NME)) AND ((@IsNull_PAGE_LOGO_URL = 1 AND [PAGE_LOGO_URL] IS NULL) OR ([PAGE_LOGO_URL] = @Original_PAGE_LOGO_URL)) AND ((@IsNull_AD_IMG1 = 1 AND [AD_IMG1] IS NULL) OR ([AD_IMG1] = @Original_AD_IMG1)) AND ((@IsNull_AD_LINK1 = 1 AND [AD_LINK1] IS NULL) OR ([AD_LINK1] = @Original_AD_LINK1)) AND ((@IsNull_AD_IMG2 = 1 AND [AD_IMG2] IS NULL) OR ([AD_IMG2] = @Original_AD_IMG2)) AND ((@IsNull_AD_LINK2 = 1 AND [AD_LINK2] IS NULL) OR ([AD_LINK2] = @Original_AD_LINK2)) AND ((@IsNull_AD_IMG3 = 1 AND [AD_IMG3] IS NULL) OR ([AD_IMG3] = @Original_AD_IMG3)) AND ((@IsNull_AD_LINK3 = 1 AND [AD_LINK3] IS NULL) OR ([AD_LINK3] = @Original_AD_LINK3)) AND ((@IsNull_DATA_SQL1 = 1 AND [DATA_SQL1] IS NULL) OR ([DATA_SQL1] = @Original_DATA_SQL1)) AND ((@IsNull_DATA_GROUP_LIST1 = 1 AND [DATA_GROUP_LIST1] IS NULL) OR ([DATA_GROUP_LIST1] = @Original_DATA_GROUP_LIST1)) AND ((@IsNull_DATA_SQL2 = 1 AND [DATA_SQL2] IS NULL) OR ([DATA_SQL2] = @Original_DATA_SQL2)) AND ((@IsNull_DATA_GROUP_LIST2 = 1 AND [DATA_GROUP_LIST2] IS NULL) OR ([DATA_GROUP_LIST2] = @Original_DATA_GROUP_LIST2)) AND ((@IsNull_DATA_SQL3 = 1 AND [DATA_SQL3] IS NULL) OR ([DATA_SQL3] = @Original_DATA_SQL3)) AND ((@IsNull_DATA_GROUP_LIST3 = 1 AND [DATA_GROUP_LIST3] IS NULL) OR ([DATA_GROUP_LIST3] = @Original_DATA_GROUP_LIST3)) AND ((@IsNull_ASPX_PAGE_URL = 1 AND [ASPX_PAGE_URL] IS NULL) OR ([ASPX_PAGE_URL] = @Original_ASPX_PAGE_URL)) AND ((@IsNull_HOST_NME = 1 AND [HOST_NME] IS NULL) OR ([HOST_NME] = @Original_HOST_NME)) AND ((@IsNull_MALL_TYPE = 1 AND [MALL_TYPE] IS NULL) OR ([MALL_TYPE] = @Original_MALL_TYPE)));
SELECT PAGE_NO, SEQ_NUM, PAGE_NME, PAGE_LOGO_URL, AD_IMG1, AD_LINK1, AD_IMG2, AD_LINK2, AD_IMG3, AD_LINK3, DATA_SQL1, DATA_GROUP_LIST1, DATA_SQL2, DATA_GROUP_LIST2, DATA_SQL3, DATA_GROUP_LIST3, ASPX_PAGE_URL, HOST_NME, MALL_TYPE FROM SHP_PAGE_MALL WHERE (PAGE_NO = @PAGE_NO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PAGE_NO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PAGE_NO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SEQ_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SEQ_NUM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PAGE_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PAGE_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PAGE_LOGO_URL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PAGE_LOGO_URL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AD_IMG1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AD_IMG1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AD_LINK1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AD_LINK1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AD_IMG2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AD_IMG2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AD_LINK2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AD_LINK2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AD_IMG3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AD_IMG3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AD_LINK3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AD_LINK3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DATA_SQL1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DATA_SQL1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DATA_GROUP_LIST1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DATA_GROUP_LIST1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DATA_SQL2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DATA_SQL2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DATA_GROUP_LIST2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DATA_GROUP_LIST2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DATA_SQL3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DATA_SQL3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DATA_GROUP_LIST3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DATA_GROUP_LIST3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ASPX_PAGE_URL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ASPX_PAGE_URL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@HOST_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="HOST_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MALL_TYPE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MALL_TYPE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PAGE_NO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PAGE_NO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SEQ_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SEQ_NUM" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SEQ_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SEQ_NUM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PAGE_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PAGE_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PAGE_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PAGE_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PAGE_LOGO_URL" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PAGE_LOGO_URL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PAGE_LOGO_URL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PAGE_LOGO_URL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AD_IMG1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AD_IMG1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AD_IMG1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AD_IMG1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AD_LINK1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AD_LINK1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AD_LINK1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AD_LINK1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AD_IMG2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AD_IMG2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AD_IMG2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AD_IMG2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AD_LINK2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AD_LINK2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AD_LINK2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AD_LINK2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AD_IMG3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AD_IMG3" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AD_IMG3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AD_IMG3" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AD_LINK3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AD_LINK3" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AD_LINK3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AD_LINK3" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DATA_SQL1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DATA_SQL1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DATA_SQL1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DATA_SQL1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DATA_GROUP_LIST1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DATA_GROUP_LIST1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DATA_GROUP_LIST1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DATA_GROUP_LIST1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DATA_SQL2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DATA_SQL2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DATA_SQL2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DATA_SQL2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DATA_GROUP_LIST2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DATA_GROUP_LIST2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DATA_GROUP_LIST2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DATA_GROUP_LIST2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DATA_SQL3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DATA_SQL3" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DATA_SQL3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DATA_SQL3" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DATA_GROUP_LIST3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DATA_GROUP_LIST3" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DATA_GROUP_LIST3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DATA_GROUP_LIST3" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ASPX_PAGE_URL" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ASPX_PAGE_URL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ASPX_PAGE_URL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ASPX_PAGE_URL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HOST_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HOST_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_HOST_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="HOST_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MALL_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MALL_TYPE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_MALL_TYPE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MALL_TYPE" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PAGE_NO" DataSetColumn="PAGE_NO" />
              <Mapping SourceColumn="SEQ_NUM" DataSetColumn="SEQ_NUM" />
              <Mapping SourceColumn="PAGE_NME" DataSetColumn="PAGE_NME" />
              <Mapping SourceColumn="PAGE_LOGO_URL" DataSetColumn="PAGE_LOGO_URL" />
              <Mapping SourceColumn="AD_IMG1" DataSetColumn="AD_IMG1" />
              <Mapping SourceColumn="AD_LINK1" DataSetColumn="AD_LINK1" />
              <Mapping SourceColumn="AD_IMG2" DataSetColumn="AD_IMG2" />
              <Mapping SourceColumn="AD_LINK2" DataSetColumn="AD_LINK2" />
              <Mapping SourceColumn="AD_IMG3" DataSetColumn="AD_IMG3" />
              <Mapping SourceColumn="AD_LINK3" DataSetColumn="AD_LINK3" />
              <Mapping SourceColumn="DATA_SQL1" DataSetColumn="DATA_SQL1" />
              <Mapping SourceColumn="DATA_GROUP_LIST1" DataSetColumn="DATA_GROUP_LIST1" />
              <Mapping SourceColumn="DATA_SQL2" DataSetColumn="DATA_SQL2" />
              <Mapping SourceColumn="DATA_GROUP_LIST2" DataSetColumn="DATA_GROUP_LIST2" />
              <Mapping SourceColumn="DATA_SQL3" DataSetColumn="DATA_SQL3" />
              <Mapping SourceColumn="DATA_GROUP_LIST3" DataSetColumn="DATA_GROUP_LIST3" />
              <Mapping SourceColumn="ASPX_PAGE_URL" DataSetColumn="ASPX_PAGE_URL" />
              <Mapping SourceColumn="HOST_NME" DataSetColumn="HOST_NME" />
              <Mapping SourceColumn="MALL_TYPE" DataSetColumn="MALL_TYPE" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="CDmShpPageMall" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="CDmShpPageMall" msprop:Generator_UserDSName="CDmShpPageMall">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="SHP_PAGE_MALL" msprop:Generator_TableClassName="SHP_PAGE_MALLDataTable" msprop:Generator_TableVarName="tableSHP_PAGE_MALL" msprop:Generator_TablePropName="SHP_PAGE_MALL" msprop:Generator_RowDeletingName="SHP_PAGE_MALLRowDeleting" msprop:Generator_UserTableName="SHP_PAGE_MALL" msprop:Generator_RowChangingName="SHP_PAGE_MALLRowChanging" msprop:Generator_RowEvHandlerName="SHP_PAGE_MALLRowChangeEventHandler" msprop:Generator_RowDeletedName="SHP_PAGE_MALLRowDeleted" msprop:Generator_RowEvArgName="SHP_PAGE_MALLRowChangeEvent" msprop:Generator_RowChangedName="SHP_PAGE_MALLRowChanged" msprop:Generator_RowClassName="SHP_PAGE_MALLRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PAGE_NO" msprop:Generator_ColumnVarNameInTable="columnPAGE_NO" msprop:Generator_ColumnPropNameInRow="PAGE_NO" msprop:Generator_ColumnPropNameInTable="PAGE_NOColumn" msprop:Generator_UserColumnName="PAGE_NO">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SEQ_NUM" msprop:Generator_ColumnVarNameInTable="columnSEQ_NUM" msprop:Generator_ColumnPropNameInRow="SEQ_NUM" msprop:Generator_ColumnPropNameInTable="SEQ_NUMColumn" msprop:Generator_UserColumnName="SEQ_NUM" type="xs:int" minOccurs="0" />
              <xs:element name="PAGE_NME" msprop:Generator_ColumnVarNameInTable="columnPAGE_NME" msprop:Generator_ColumnPropNameInRow="PAGE_NME" msprop:Generator_ColumnPropNameInTable="PAGE_NMEColumn" msprop:Generator_UserColumnName="PAGE_NME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PAGE_LOGO_URL" msprop:Generator_ColumnVarNameInTable="columnPAGE_LOGO_URL" msprop:Generator_ColumnPropNameInRow="PAGE_LOGO_URL" msprop:Generator_ColumnPropNameInTable="PAGE_LOGO_URLColumn" msprop:Generator_UserColumnName="PAGE_LOGO_URL" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AD_IMG1" msprop:Generator_ColumnVarNameInTable="columnAD_IMG1" msprop:Generator_ColumnPropNameInRow="AD_IMG1" msprop:Generator_ColumnPropNameInTable="AD_IMG1Column" msprop:Generator_UserColumnName="AD_IMG1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AD_LINK1" msprop:Generator_ColumnVarNameInTable="columnAD_LINK1" msprop:Generator_ColumnPropNameInRow="AD_LINK1" msprop:Generator_ColumnPropNameInTable="AD_LINK1Column" msprop:Generator_UserColumnName="AD_LINK1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AD_IMG2" msprop:Generator_ColumnVarNameInTable="columnAD_IMG2" msprop:Generator_ColumnPropNameInRow="AD_IMG2" msprop:Generator_ColumnPropNameInTable="AD_IMG2Column" msprop:Generator_UserColumnName="AD_IMG2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AD_LINK2" msprop:Generator_ColumnVarNameInTable="columnAD_LINK2" msprop:Generator_ColumnPropNameInRow="AD_LINK2" msprop:Generator_ColumnPropNameInTable="AD_LINK2Column" msprop:Generator_UserColumnName="AD_LINK2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AD_IMG3" msprop:Generator_ColumnVarNameInTable="columnAD_IMG3" msprop:Generator_ColumnPropNameInRow="AD_IMG3" msprop:Generator_ColumnPropNameInTable="AD_IMG3Column" msprop:Generator_UserColumnName="AD_IMG3" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AD_LINK3" msprop:Generator_ColumnVarNameInTable="columnAD_LINK3" msprop:Generator_ColumnPropNameInRow="AD_LINK3" msprop:Generator_ColumnPropNameInTable="AD_LINK3Column" msprop:Generator_UserColumnName="AD_LINK3" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DATA_SQL1" msprop:Generator_ColumnVarNameInTable="columnDATA_SQL1" msprop:Generator_ColumnPropNameInRow="DATA_SQL1" msprop:Generator_ColumnPropNameInTable="DATA_SQL1Column" msprop:Generator_UserColumnName="DATA_SQL1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DATA_GROUP_LIST1" msprop:Generator_ColumnVarNameInTable="columnDATA_GROUP_LIST1" msprop:Generator_ColumnPropNameInRow="DATA_GROUP_LIST1" msprop:Generator_ColumnPropNameInTable="DATA_GROUP_LIST1Column" msprop:Generator_UserColumnName="DATA_GROUP_LIST1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DATA_SQL2" msprop:Generator_ColumnVarNameInTable="columnDATA_SQL2" msprop:Generator_ColumnPropNameInRow="DATA_SQL2" msprop:Generator_ColumnPropNameInTable="DATA_SQL2Column" msprop:Generator_UserColumnName="DATA_SQL2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DATA_GROUP_LIST2" msprop:Generator_ColumnVarNameInTable="columnDATA_GROUP_LIST2" msprop:Generator_ColumnPropNameInRow="DATA_GROUP_LIST2" msprop:Generator_ColumnPropNameInTable="DATA_GROUP_LIST2Column" msprop:Generator_UserColumnName="DATA_GROUP_LIST2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DATA_SQL3" msprop:Generator_ColumnVarNameInTable="columnDATA_SQL3" msprop:Generator_ColumnPropNameInRow="DATA_SQL3" msprop:Generator_ColumnPropNameInTable="DATA_SQL3Column" msprop:Generator_UserColumnName="DATA_SQL3" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DATA_GROUP_LIST3" msprop:Generator_ColumnVarNameInTable="columnDATA_GROUP_LIST3" msprop:Generator_ColumnPropNameInRow="DATA_GROUP_LIST3" msprop:Generator_ColumnPropNameInTable="DATA_GROUP_LIST3Column" msprop:Generator_UserColumnName="DATA_GROUP_LIST3" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ASPX_PAGE_URL" msprop:Generator_ColumnVarNameInTable="columnASPX_PAGE_URL" msprop:Generator_ColumnPropNameInRow="ASPX_PAGE_URL" msprop:Generator_ColumnPropNameInTable="ASPX_PAGE_URLColumn" msprop:Generator_UserColumnName="ASPX_PAGE_URL" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="HOST_NME" msprop:Generator_ColumnVarNameInTable="columnHOST_NME" msprop:Generator_ColumnPropNameInRow="HOST_NME" msprop:Generator_ColumnPropNameInTable="HOST_NMEColumn" msprop:Generator_UserColumnName="HOST_NME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MALL_TYPE" msprop:Generator_ColumnVarNameInTable="columnMALL_TYPE" msprop:Generator_ColumnPropNameInRow="MALL_TYPE" msprop:Generator_ColumnPropNameInTable="MALL_TYPEColumn" msprop:Generator_UserColumnName="MALL_TYPE" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:SHP_PAGE_MALL" />
      <xs:field xpath="mstns:PAGE_NO" />
    </xs:unique>
  </xs:element>
</xs:schema>